2.1.2.1 Collection categories
| Property | Value |
| Collection name | categories |
| Technical name | |
| Activated | true |
| Id | |
| $ref | |
| Description | |
| Database | online_course |
| Capped | |
| Time series | |
| Size | |
| Max | |
| Storage engine | WiredTiger |
| Config String | |
| Validation level | Off |
| Validation action | Warn |
| Encryption metadata | |
| Additional properties | false |
| Comments | |
2.1.2.1.3.1 Field _id
| Property | Value |
| Name | _id |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | true |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.1.3.2 Field name
| Property | Value |
| Name | name |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.1.3.3 Field slug
| Property | Value |
| Name | slug |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.1.3.4 Field parent
| Property | Value |
| Name | parent |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | categories |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk categories. to categories. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.1.3.5 Field status
| Property | Value |
| Name | status |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.1.3.6 Field history
Parent field: categories
Child field(s):
| Property | Value |
| Name | history |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.1.3.7 Field createdAt
| Property | Value |
| Name | createdAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.1.3.8 Field createdBy
| Property | Value |
| Name | createdBy |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.1.3.9 Field updatedAt
| Property | Value |
| Name | updatedAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.1.3.10 Field updatedBy
| Property | Value |
| Name | updatedBy |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
{
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"title": "categories",
"properties": {
"_id": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"name": {
"type": "string"
},
"slug": {
"type": "string"
},
"parent": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"status": {
"type": "string"
},
"history": {
"type": "object",
"properties": {
"createdAt": {
"type": "string",
"format": "date-time"
},
"createdBy": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"updatedAt": {
"type": "string",
"format": "date-time"
},
"updatedBy": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
}
},
"additionalProperties": false,
"required": [
"createdAt",
"createdBy"
]
}
},
"additionalProperties": false,
"required": [
"name",
"slug",
"status",
"history"
]
}{
"_id": ObjectId("279c1f0cd3afbc5ea118ecb8"),
"name": "Lorem",
"slug": "Lorem",
"parent": ObjectId("3a791abeed390cca12e9a59c"),
"status": "Lorem",
"history": {
"createdAt": ISODate("2016-04-08T15:06:21.595Z"),
"createdBy": ObjectId("450edb1ecdaf3046bc573965"),
"updatedAt": ISODate("2016-04-08T15:06:21.595Z"),
"updatedBy": ObjectId("f76f5dcabbcaba1be5f8209e")
}
}use online_course;
db.createCollection("categories", {
"capped": false,
"validator": {
"$jsonSchema": {
"bsonType": "object",
"title": "categories",
"properties": {
"_id": {
"bsonType": "objectId"
},
"name": {
"bsonType": "string"
},
"slug": {
"bsonType": "string"
},
"parent": {
"bsonType": "objectId"
},
"status": {
"bsonType": "string"
},
"history": {
"bsonType": "object",
"properties": {
"createdAt": {
"bsonType": "date"
},
"createdBy": {
"bsonType": "objectId"
},
"updatedAt": {
"bsonType": "date"
},
"updatedBy": {
"bsonType": "objectId"
}
},
"additionalProperties": false,
"required": [
"createdAt",
"createdBy"
]
}
},
"additionalProperties": false,
"required": [
"name",
"slug",
"status",
"history"
]
}
},
"validationLevel": "off",
"validationAction": "warn"
});2.1.2.2 Collection comments
| Property | Value |
| Collection name | comments |
| Technical name | |
| Activated | true |
| Id | |
| $ref | |
| Description | |
| Database | online_course |
| Capped | |
| Time series | |
| Size | |
| Max | |
| Storage engine | WiredTiger |
| Config String | |
| Validation level | Off |
| Validation action | Warn |
| Encryption metadata | |
| Additional properties | false |
| Comments | |
2.1.2.2.3.1 Field _id
| Property | Value |
| Name | _id |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | false |
| Primary key | true |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.2.3.2 Field course
| Property | Value |
| Name | course |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | courses |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk courses. to comments. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.2.3.3 Field unit
| Property | Value |
| Name | unit |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.2.3.4 Field parent
| Property | Value |
| Name | parent |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | comments |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk comments. to comments. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.2.3.5 Field content
| Property | Value |
| Name | content |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.2.3.6 Field user
| Property | Value |
| Name | user |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to comments. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.2.3.7 Field timestamps
Parent field: comments
Child field(s):
| Property | Value |
| Name | timestamps |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.2.3.8 Field createdAt
| Property | Value |
| Name | createdAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.2.3.9 Field updatedAt
| Property | Value |
| Name | updatedAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
{
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"title": "comments",
"properties": {
"_id": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"course": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"unit": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"parent": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"content": {
"type": "string"
},
"user": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"timestamps": {
"type": "object",
"properties": {
"createdAt": {
"type": "string",
"format": "date-time"
},
"updatedAt": {
"type": "string",
"format": "date-time"
}
},
"additionalProperties": false,
"required": [
"createdAt"
]
}
},
"additionalProperties": false,
"required": [
"course",
"unit",
"content",
"user",
"timestamps"
]
}{
"_id": ObjectId("dcc7ffb903f5c358ca7adcad"),
"course": ObjectId("ab6d9dca1bbdde7643fdd7a5"),
"unit": ObjectId("f74479b9c41da0841fcfee40"),
"parent": ObjectId("b7efef18de2cfd06aaa2d169"),
"content": "Lorem",
"user": ObjectId("cfbd2dacccb5efcee1b81e44"),
"timestamps": {
"createdAt": ISODate("2016-04-08T15:06:21.595Z"),
"updatedAt": ISODate("2016-04-08T15:06:21.595Z")
}
}use online_course;
db.createCollection("comments", {
"capped": false,
"validator": {
"$jsonSchema": {
"bsonType": "object",
"title": "comments",
"properties": {
"_id": {
"bsonType": "objectId"
},
"course": {
"bsonType": "objectId"
},
"unit": {
"bsonType": "objectId"
},
"parent": {
"bsonType": "objectId"
},
"content": {
"bsonType": "string"
},
"user": {
"bsonType": "objectId"
},
"timestamps": {
"bsonType": "object",
"properties": {
"createdAt": {
"bsonType": "date"
},
"updatedAt": {
"bsonType": "date"
}
},
"additionalProperties": false,
"required": [
"createdAt"
]
}
},
"additionalProperties": false,
"required": [
"course",
"unit",
"content",
"user",
"timestamps"
]
}
},
"validationLevel": "off",
"validationAction": "warn"
});2.1.2.3 Collection configurations
| Property | Value |
| Collection name | configurations |
| Technical name | |
| Activated | true |
| Id | |
| $ref | |
| Description | |
| Database | online_course |
| Capped | |
| Time series | |
| Size | |
| Max | |
| Storage engine | WiredTiger |
| Config String | |
| Validation level | Off |
| Validation action | Warn |
| Encryption metadata | |
| Additional properties | false |
| Comments | |
2.1.2.3.3.1 Field _id
| Property | Value |
| Name | _id |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | false |
| Primary key | true |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.3.3.2 Field course
Parent field: configurations
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| priceTiers | array | true | | | |
| Property | Value |
| Name | course |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.3.3.3 Field priceTiers
Parent field: course
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| [0] | string | false | | | |
| Property | Value |
| Name | priceTiers |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | array |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Min items | |
| Max items | |
| Unique items | |
| Additional items | true |
| Comments | |
2.1.2.3.3.4 Field [0]
| Property | Value |
| Display name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.3.3.5 Field money
Parent field: configurations
Child field(s):
| Property | Value |
| Name | money |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.3.3.6 Field instructorCommission
| Property | Value |
| Name | instructorCommission |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.3.3.7 Field history
Parent field: configurations
Child field(s):
| Property | Value |
| Name | history |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.3.3.8 Field createdAt
| Property | Value |
| Name | createdAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.3.3.9 Field createdBy
| Property | Value |
| Name | createdBy |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.3.3.10 Field updatedAt
| Property | Value |
| Name | updatedAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.3.3.11 Field updatedBy
| Property | Value |
| Name | updatedBy |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
{
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"title": "configurations",
"properties": {
"_id": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"course": {
"type": "object",
"properties": {
"priceTiers": {
"type": "array",
"additionalItems": true,
"items": {
"type": "string"
}
}
},
"additionalProperties": false,
"required": [
"priceTiers"
]
},
"money": {
"type": "object",
"properties": {
"instructorCommission": {
"type": "number"
}
},
"additionalProperties": false,
"required": [
"instructorCommission"
]
},
"history": {
"type": "object",
"properties": {
"createdAt": {
"type": "string",
"format": "date-time"
},
"createdBy": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"updatedAt": {
"type": "string",
"format": "date-time"
},
"updatedBy": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
}
},
"additionalProperties": false,
"required": [
"createdAt",
"createdBy"
]
}
},
"additionalProperties": false,
"required": [
"course",
"money",
"history"
]
}{
"_id": ObjectId("3fcc0845ca6abed9fe5dff2f"),
"course": {
"priceTiers": [
"Lorem"
]
},
"money": {
"instructorCommission": 87
},
"history": {
"createdAt": ISODate("2016-04-08T15:06:21.595Z"),
"createdBy": ObjectId("ed84e5e0ba23815bae6de6c0"),
"updatedAt": ISODate("2016-04-08T15:06:21.595Z"),
"updatedBy": ObjectId("cda93729e4512d7dcfd9b5d1")
}
}use online_course;
db.createCollection("configurations", {
"capped": false,
"validator": {
"$jsonSchema": {
"bsonType": "object",
"title": "configurations",
"properties": {
"_id": {
"bsonType": "objectId"
},
"course": {
"bsonType": "object",
"properties": {
"priceTiers": {
"bsonType": "array",
"additionalItems": true,
"items": {
"bsonType": "string"
}
}
},
"additionalProperties": false,
"required": [
"priceTiers"
]
},
"money": {
"bsonType": "object",
"properties": {
"instructorCommission": {
"bsonType": "number"
}
},
"additionalProperties": false,
"required": [
"instructorCommission"
]
},
"history": {
"bsonType": "object",
"properties": {
"createdAt": {
"bsonType": "date"
},
"createdBy": {
"bsonType": "objectId"
},
"updatedAt": {
"bsonType": "date"
},
"updatedBy": {
"bsonType": "objectId"
}
},
"additionalProperties": false,
"required": [
"createdAt",
"createdBy"
]
}
},
"additionalProperties": false,
"required": [
"course",
"money",
"history"
]
}
},
"validationLevel": "off",
"validationAction": "warn"
});2.1.2.4 Collection courses
| Property | Value |
| Collection name | courses |
| Technical name | |
| Activated | true |
| Id | |
| $ref | |
| Description | |
| Database | online_course |
| Capped | |
| Time series | |
| Size | |
| Max | |
| Storage engine | WiredTiger |
| Config String | |
| Validation level | Off |
| Validation action | Warn |
| Encryption metadata | |
| Additional properties | false |
| Comments | |
2.1.2.4.3.1 Field _id
| Property | Value |
| Name | _id |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | true |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.4.3.2 Field status
| Property | Value |
| Name | status |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.3 Field categories
Parent field: courses
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| [0] | objectId | false | | | |
| Property | Value |
| Name | categories |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | array |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Min items | |
| Max items | |
| Unique items | |
| Additional items | true |
| Comments | |
2.1.2.4.3.4 Field [0]
| Property | Value |
| Display name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Primary key | |
| Foreign collection | categories |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk categories. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.4.3.5 Field basicInfo
Parent field: courses
Child field(s):
| Property | Value |
| Name | basicInfo |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.4.3.6 Field title
| Property | Value |
| Name | title |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.7 Field slug
| Property | Value |
| Name | slug |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | false |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.8 Field subtitle
| Property | Value |
| Name | subtitle |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.9 Field price
| Property | Value |
| Name | price |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.10 Field lan
| Property | Value |
| Name | lan |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.11 Field level
| Property | Value |
| Name | level |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.12 Field currency
| Property | Value |
| Name | currency |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.13 Field isFree
| Property | Value |
| Name | isFree |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | boolean |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | false |
| Sample | |
| Comments | |
2.1.2.4.3.14 Field discount
| Property | Value |
| Name | discount |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.15 Field image
| Property | Value |
| Name | image |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.16 Field details
Parent field: courses
Child field(s):
| Property | Value |
| Name | details |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.4.3.17 Field requirements
Parent field: details
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| [0] | string | false | | | |
| Property | Value |
| Name | requirements |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | array |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Min items | |
| Max items | |
| Unique items | |
| Additional items | true |
| Comments | |
2.1.2.4.3.18 Field [0]
| Property | Value |
| Display name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.19 Field objectives
Parent field: details
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| [0] | string | false | | | |
| Property | Value |
| Name | objectives |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | array |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Min items | |
| Max items | |
| Unique items | |
| Additional items | true |
| Comments | |
2.1.2.4.3.20 Field [0]
| Property | Value |
| Display name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.21 Field sections
Parent field: details
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| [0] | document | false | | | |
| Property | Value |
| Name | sections |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | array |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Min items | |
| Max items | |
| Unique items | |
| Additional items | true |
| Comments | |
2.1.2.4.3.22 Field [0]
Parent field: sections
Child field(s):
| Property | Value |
| Display name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.4.3.23 Field title
| Property | Value |
| Name | title |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.24 Field objective
| Property | Value |
| Name | objective |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.25 Field numLectures
| Property | Value |
| Name | numLectures |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.26 Field duration
| Property | Value |
| Name | duration |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.27 Field units
Parent field: [0]
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| [0] | document | false | | | |
| Property | Value |
| Name | units |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | array |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Min items | |
| Max items | |
| Unique items | |
| Additional items | true |
| Comments | |
2.1.2.4.3.28 Field [0]
Parent field: units
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| lecture | objectId | false | | | |
| quiz | objectId | false | | | |
| type | string | false | | | |
| Property | Value |
| Display name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.4.3.29 Field lecture
| Property | Value |
| Name | lecture |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | lectures |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk lectures. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.4.3.30 Field quiz
| Property | Value |
| Name | quiz |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | quizzes |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk quizzes. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.4.3.31 Field type
| Property | Value |
| Name | type |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.32 Field description
| Property | Value |
| Name | description |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.33 Field suitableLearner
Parent field: details
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| [0] | string | false | | | |
| Property | Value |
| Name | suitableLearner |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | array |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Min items | |
| Max items | |
| Unique items | |
| Additional items | true |
| Comments | |
2.1.2.4.3.34 Field [0]
| Property | Value |
| Display name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.35 Field meta
Parent field: courses
Child field(s):
| Property | Value |
| Name | meta |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.4.3.36 Field studentCount
| Property | Value |
| Name | studentCount |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.37 Field avgRatingScore
| Property | Value |
| Name | avgRatingScore |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.38 Field ratingCount
| Property | Value |
| Name | ratingCount |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.39 Field contentVideoLength
| Property | Value |
| Name | contentVideoLength |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.40 Field messages
Parent field: courses
Child field(s):
| Property | Value |
| Name | messages |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.4.3.41 Field welcome
| Property | Value |
| Name | welcome |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.42 Field congratulation
| Property | Value |
| Name | congratulation |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.43 Field promotions
Parent field: courses
Child field(s):
| Property | Value |
| Name | promotions |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.4.3.44 Field enabled
| Property | Value |
| Name | enabled |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | boolean |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.4.3.45 Field discountPrice
| Property | Value |
| Name | discountPrice |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.46 Field startAt
| Property | Value |
| Name | startAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.47 Field endAt
| Property | Value |
| Name | endAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.48 Field history
Parent field: courses
Child field(s):
| Property | Value |
| Name | history |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.4.3.49 Field publishedAt
| Property | Value |
| Name | publishedAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.50 Field createdAt
| Property | Value |
| Name | createdAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.51 Field createdBy
| Property | Value |
| Name | createdBy |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.4.3.52 Field updatedAt
| Property | Value |
| Name | updatedAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.4.3.53 Field updatedBy
| Property | Value |
| Name | updatedBy |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
{
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"title": "courses",
"properties": {
"_id": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"status": {
"type": "string"
},
"categories": {
"type": "array",
"additionalItems": true,
"items": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
}
},
"basicInfo": {
"type": "object",
"properties": {
"title": {
"type": "string"
},
"slug": {
"type": "string"
},
"subtitle": {
"type": "string"
},
"price": {
"type": "number"
},
"lan": {
"type": "string"
},
"level": {
"type": "string"
},
"currency": {
"type": "string"
},
"isFree": {
"type": "boolean",
"default": false
},
"discount": {
"type": "number"
},
"image": {
"type": "string"
}
},
"additionalProperties": false,
"required": [
"title"
]
},
"details": {
"type": "object",
"properties": {
"requirements": {
"type": "array",
"additionalItems": true,
"items": {
"type": "string"
}
},
"objectives": {
"type": "array",
"additionalItems": true,
"items": {
"type": "string"
}
},
"sections": {
"type": "array",
"additionalItems": true,
"items": {
"type": "object",
"properties": {
"title": {
"type": "string"
},
"objective": {
"type": "string"
},
"numLectures": {
"type": "number"
},
"duration": {
"type": "number"
},
"units": {
"type": "array",
"additionalItems": true,
"items": {
"type": "object",
"properties": {
"lecture": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"quiz": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"type": {
"type": "string"
}
},
"additionalProperties": false
}
}
},
"additionalProperties": false
}
},
"description": {
"type": "string"
},
"suitableLearner": {
"type": "array",
"additionalItems": true,
"items": {
"type": "string"
}
}
},
"additionalProperties": false
},
"meta": {
"type": "object",
"properties": {
"studentCount": {
"type": "number"
},
"avgRatingScore": {
"type": "number"
},
"ratingCount": {
"type": "number"
},
"contentVideoLength": {
"type": "number"
}
},
"additionalProperties": false
},
"messages": {
"type": "object",
"properties": {
"welcome": {
"type": "string"
},
"congratulation": {
"type": "string"
}
},
"additionalProperties": false
},
"promotions": {
"type": "object",
"properties": {
"enabled": {
"type": "boolean"
},
"discountPrice": {
"type": "number"
},
"startAt": {
"type": "string",
"format": "date-time"
},
"endAt": {
"type": "string",
"format": "date-time"
}
},
"additionalProperties": false
},
"history": {
"type": "object",
"properties": {
"publishedAt": {
"type": "string"
},
"createdAt": {
"type": "string",
"format": "date-time"
},
"createdBy": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"updatedAt": {
"type": "string",
"format": "date-time"
},
"updatedBy": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
}
},
"additionalProperties": false,
"required": [
"createdAt",
"createdBy"
]
}
},
"additionalProperties": false,
"required": [
"status",
"history"
]
}{
"_id": ObjectId("5bfe515a1fdb0f57bbbb54f0"),
"status": "Lorem",
"categories": [
ObjectId("bfc3acabfc2bdd4a31bfdb69")
],
"basicInfo": {
"title": "Lorem",
"slug": "Lorem",
"subtitle": "Lorem",
"price": 41,
"lan": "Lorem",
"level": "Lorem",
"currency": "Lorem",
"isFree": false,
"discount": -23,
"image": "Lorem"
},
"details": {
"requirements": [
"Lorem"
],
"objectives": [
"Lorem"
],
"sections": [
{
"title": "Lorem",
"objective": "Lorem",
"numLectures": -96,
"duration": -22,
"units": [
{
"lecture": ObjectId("9bedac0edd8bd5594670afad"),
"quiz": ObjectId("ddd8a6e5795387bbd4fefd5f"),
"type": "Lorem"
}
]
}
],
"description": "Lorem",
"suitableLearner": [
"Lorem"
]
},
"meta": {
"studentCount": -21,
"avgRatingScore": 56,
"ratingCount": -46,
"contentVideoLength": -56
},
"messages": {
"welcome": "Lorem",
"congratulation": "Lorem"
},
"promotions": {
"enabled": true,
"discountPrice": 35,
"startAt": ISODate("2016-04-08T15:06:21.595Z"),
"endAt": ISODate("2016-04-08T15:06:21.595Z")
},
"history": {
"publishedAt": "Lorem",
"createdAt": ISODate("2016-04-08T15:06:21.595Z"),
"createdBy": ObjectId("dedc2edc8d3b552acd12ee74"),
"updatedAt": ISODate("2016-04-08T15:06:21.595Z"),
"updatedBy": ObjectId("5ebd5c39589bbe7f28fc33cc")
}
}use online_course;
db.createCollection("courses", {
"capped": false,
"validator": {
"$jsonSchema": {
"bsonType": "object",
"title": "courses",
"properties": {
"_id": {
"bsonType": "objectId"
},
"status": {
"bsonType": "string"
},
"categories": {
"bsonType": "array",
"additionalItems": true,
"items": {
"bsonType": "objectId"
}
},
"basicInfo": {
"bsonType": "object",
"properties": {
"title": {
"bsonType": "string"
},
"slug": {
"bsonType": "string"
},
"subtitle": {
"bsonType": "string"
},
"price": {
"bsonType": "number"
},
"lan": {
"bsonType": "string"
},
"level": {
"bsonType": "string"
},
"currency": {
"bsonType": "string"
},
"isFree": {
"bsonType": "bool"
},
"discount": {
"bsonType": "number"
},
"image": {
"bsonType": "string"
}
},
"additionalProperties": false,
"required": [
"title"
]
},
"details": {
"bsonType": "object",
"properties": {
"requirements": {
"bsonType": "array",
"additionalItems": true,
"items": {
"bsonType": "string"
}
},
"objectives": {
"bsonType": "array",
"additionalItems": true,
"items": {
"bsonType": "string"
}
},
"sections": {
"bsonType": "array",
"additionalItems": true,
"items": {
"bsonType": "object",
"properties": {
"title": {
"bsonType": "string"
},
"objective": {
"bsonType": "string"
},
"numLectures": {
"bsonType": "number"
},
"duration": {
"bsonType": "number"
},
"units": {
"bsonType": "array",
"additionalItems": true,
"items": {
"bsonType": "object",
"properties": {
"lecture": {
"bsonType": "objectId"
},
"quiz": {
"bsonType": "objectId"
},
"type": {
"bsonType": "string"
}
},
"additionalProperties": false
}
}
},
"additionalProperties": false
}
},
"description": {
"bsonType": "string"
},
"suitableLearner": {
"bsonType": "array",
"additionalItems": true,
"items": {
"bsonType": "string"
}
}
},
"additionalProperties": false
},
"meta": {
"bsonType": "object",
"properties": {
"studentCount": {
"bsonType": "number"
},
"avgRatingScore": {
"bsonType": "number"
},
"ratingCount": {
"bsonType": "number"
},
"contentVideoLength": {
"bsonType": "number"
}
},
"additionalProperties": false
},
"messages": {
"bsonType": "object",
"properties": {
"welcome": {
"bsonType": "string"
},
"congratulation": {
"bsonType": "string"
}
},
"additionalProperties": false
},
"promotions": {
"bsonType": "object",
"properties": {
"enabled": {
"bsonType": "bool"
},
"discountPrice": {
"bsonType": "number"
},
"startAt": {
"bsonType": "date"
},
"endAt": {
"bsonType": "date"
}
},
"additionalProperties": false
},
"history": {
"bsonType": "object",
"properties": {
"publishedAt": {
"bsonType": "string"
},
"createdAt": {
"bsonType": "date"
},
"createdBy": {
"bsonType": "objectId"
},
"updatedAt": {
"bsonType": "date"
},
"updatedBy": {
"bsonType": "objectId"
}
},
"additionalProperties": false,
"required": [
"createdAt",
"createdBy"
]
}
},
"additionalProperties": false,
"required": [
"status",
"history"
]
}
},
"validationLevel": "off",
"validationAction": "warn"
});2.1.2.5 Collection document_permissions
| Property | Value |
| Collection name | document_permissions |
| Technical name | |
| Activated | true |
| Id | |
| $ref | |
| Description | |
| Database | online_course |
| Capped | |
| Time series | |
| Size | |
| Max | |
| Storage engine | WiredTiger |
| Config String | |
| Validation level | Off |
| Validation action | Warn |
| Encryption metadata | |
| Additional properties | false |
| Comments | |
2.1.2.5.3.1 Field _id
| Property | Value |
| Name | _id |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | false |
| Primary key | true |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.5.3.2 Field name
| Property | Value |
| Name | name |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.5.3.3 Field type
| Property | Value |
| Name | type |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.5.3.4 Field permissions
Parent field: document_permissions
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| [0] | string | false | | | |
| Property | Value |
| Name | permissions |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | array |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Min items | |
| Max items | |
| Unique items | |
| Additional items | true |
| Comments | |
2.1.2.5.3.5 Field [0]
| Property | Value |
| Display name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.5.3.6 Field ordering
| Property | Value |
| Name | ordering |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
{
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"title": "document_permissions",
"properties": {
"_id": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"name": {
"type": "string"
},
"type": {
"type": "string"
},
"permissions": {
"type": "array",
"additionalItems": true,
"items": {
"type": "string"
}
},
"ordering": {
"type": "number"
}
},
"additionalProperties": false,
"required": [
"name",
"type",
"permissions",
"ordering"
]
}{
"_id": ObjectId("eabe5e6dba6ba41bb38cd8d9"),
"name": "Lorem",
"type": "Lorem",
"permissions": [
"Lorem"
],
"ordering": -37
}use online_course;
db.createCollection("document_permissions", {
"capped": false,
"validator": {
"$jsonSchema": {
"bsonType": "object",
"title": "document_permissions",
"properties": {
"_id": {
"bsonType": "objectId"
},
"name": {
"bsonType": "string"
},
"type": {
"bsonType": "string"
},
"permissions": {
"bsonType": "array",
"additionalItems": true,
"items": {
"bsonType": "string"
}
},
"ordering": {
"bsonType": "number"
}
},
"additionalProperties": false,
"required": [
"name",
"type",
"permissions",
"ordering"
]
}
},
"validationLevel": "off",
"validationAction": "warn"
});2.1.2.6 Collection files
| Property | Value |
| Collection name | files |
| Technical name | |
| Activated | true |
| Id | |
| $ref | |
| Description | |
| Database | online_course |
| Capped | |
| Time series | |
| Size | |
| Max | |
| Storage engine | WiredTiger |
| Config String | |
| Validation level | Off |
| Validation action | Warn |
| Encryption metadata | |
| Additional properties | false |
| Comments | |
2.1.2.6.3.1 Field _id
| Property | Value |
| Name | _id |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | true |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.6.3.2 Field url
| Property | Value |
| Name | url |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.6.3.3 Field name
| Property | Value |
| Name | name |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.6.3.4 Field status
| Property | Value |
| Name | status |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.6.3.5 Field size
| Property | Value |
| Name | size |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.6.3.6 Field type
| Property | Value |
| Name | type |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.6.3.7 Field thumbnailUrl
| Property | Value |
| Name | thumbnailUrl |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.6.3.8 Field duration
| Property | Value |
| Name | duration |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.6.3.9 Field history
Parent field: files
Child field(s):
| Property | Value |
| Name | history |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.6.3.10 Field createdAt
| Property | Value |
| Name | createdAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.6.3.11 Field createdBy
| Property | Value |
| Name | createdBy |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.6.3.12 Field updatedAt
| Property | Value |
| Name | updatedAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.6.3.13 Field updatedBy
| Property | Value |
| Name | updatedBy |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
{
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"title": "files",
"properties": {
"_id": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"url": {
"type": "string"
},
"name": {
"type": "string"
},
"status": {
"type": "string"
},
"size": {
"type": "number"
},
"type": {
"type": "string"
},
"thumbnailUrl": {
"type": "string"
},
"duration": {
"type": "number"
},
"history": {
"type": "object",
"properties": {
"createdAt": {
"type": "string",
"format": "date-time"
},
"createdBy": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"updatedAt": {
"type": "string",
"format": "date-time"
},
"updatedBy": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
}
},
"additionalProperties": false,
"required": [
"createdAt",
"createdBy"
]
}
},
"additionalProperties": false,
"required": [
"url",
"name",
"status",
"history"
]
}{
"_id": ObjectId("43dfe60110f3c35dfa4a94bf"),
"url": "Lorem",
"name": "Lorem",
"status": "Lorem",
"size": 1,
"type": "Lorem",
"thumbnailUrl": "Lorem",
"duration": -24,
"history": {
"createdAt": ISODate("2016-04-08T15:06:21.595Z"),
"createdBy": ObjectId("7ca461e57b6407fa6ec89ce5"),
"updatedAt": ISODate("2016-04-08T15:06:21.595Z"),
"updatedBy": ObjectId("be0c8a82eff8bb40ab27cfe6")
}
}use online_course;
db.createCollection("files", {
"capped": false,
"validator": {
"$jsonSchema": {
"bsonType": "object",
"title": "files",
"properties": {
"_id": {
"bsonType": "objectId"
},
"url": {
"bsonType": "string"
},
"name": {
"bsonType": "string"
},
"status": {
"bsonType": "string"
},
"size": {
"bsonType": "number"
},
"type": {
"bsonType": "string"
},
"thumbnailUrl": {
"bsonType": "string"
},
"duration": {
"bsonType": "number"
},
"history": {
"bsonType": "object",
"properties": {
"createdAt": {
"bsonType": "date"
},
"createdBy": {
"bsonType": "objectId"
},
"updatedAt": {
"bsonType": "date"
},
"updatedBy": {
"bsonType": "objectId"
}
},
"additionalProperties": false,
"required": [
"createdAt",
"createdBy"
]
}
},
"additionalProperties": false,
"required": [
"url",
"name",
"status",
"history"
]
}
},
"validationLevel": "off",
"validationAction": "warn"
});2.1.2.7 Collection lectures
| Property | Value |
| Collection name | lectures |
| Technical name | |
| Activated | true |
| Id | |
| $ref | |
| Description | |
| Database | online_course |
| Capped | |
| Time series | |
| Size | |
| Max | |
| Storage engine | WiredTiger |
| Config String | |
| Validation level | Off |
| Validation action | Warn |
| Encryption metadata | |
| Additional properties | false |
| Comments | |
2.1.2.7.3.1 Field _id
| Property | Value |
| Name | _id |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | true |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.7.3.2 Field title
| Property | Value |
| Name | title |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.7.3.3 Field description
| Property | Value |
| Name | description |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.7.3.4 Field video
| Property | Value |
| Name | video |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | files |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk files. to lectures. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.7.3.5 Field thumbnail
| Property | Value |
| Name | thumbnail |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | files |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk files. to lectures. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.7.3.6 Field resources
Parent field: lectures
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| [0] | objectId | false | | | |
| Property | Value |
| Name | resources |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | array |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Min items | |
| Max items | |
| Unique items | |
| Additional items | true |
| Comments | |
2.1.2.7.3.7 Field [0]
| Property | Value |
| Display name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Primary key | |
| Foreign collection | files |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk files. to lectures. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.7.3.8 Field history
Parent field: lectures
Child field(s):
| Property | Value |
| Name | history |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.7.3.9 Field createdAt
| Property | Value |
| Name | createdAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.7.3.10 Field createdBy
| Property | Value |
| Name | createdBy |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.7.3.11 Field updatedAt
| Property | Value |
| Name | updatedAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.7.3.12 Field updatedBy
| Property | Value |
| Name | updatedBy |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
{
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"title": "lectures",
"properties": {
"_id": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"title": {
"type": "string"
},
"description": {
"type": "string"
},
"video": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"thumbnail": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"resources": {
"type": "array",
"additionalItems": true,
"items": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
}
},
"history": {
"type": "object",
"properties": {
"createdAt": {
"type": "string",
"format": "date-time"
},
"createdBy": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"updatedAt": {
"type": "string",
"format": "date-time"
},
"updatedBy": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
}
},
"additionalProperties": false,
"required": [
"createdAt",
"createdBy"
]
}
},
"additionalProperties": false,
"required": [
"title",
"history"
]
}{
"_id": ObjectId("e1cd62e9d9a7ead0197fdf8c"),
"title": "Lorem",
"description": "Lorem",
"video": ObjectId("f3ebf2a749ec973a65b97fca"),
"thumbnail": ObjectId("d1fe3f7ef3569ab9db2a57ac"),
"resources": [
ObjectId("66799e7a98a17feee9ddaea9")
],
"history": {
"createdAt": ISODate("2016-04-08T15:06:21.595Z"),
"createdBy": ObjectId("20ce437c724e28e4cefcf4d7"),
"updatedAt": ISODate("2016-04-08T15:06:21.595Z"),
"updatedBy": ObjectId("1bbca7f9089ac32f6228addd")
}
}use online_course;
db.createCollection("lectures", {
"capped": false,
"validator": {
"$jsonSchema": {
"bsonType": "object",
"title": "lectures",
"properties": {
"_id": {
"bsonType": "objectId"
},
"title": {
"bsonType": "string"
},
"description": {
"bsonType": "string"
},
"video": {
"bsonType": "objectId"
},
"thumbnail": {
"bsonType": "objectId"
},
"resources": {
"bsonType": "array",
"additionalItems": true,
"items": {
"bsonType": "objectId"
}
},
"history": {
"bsonType": "object",
"properties": {
"createdAt": {
"bsonType": "date"
},
"createdBy": {
"bsonType": "objectId"
},
"updatedAt": {
"bsonType": "date"
},
"updatedBy": {
"bsonType": "objectId"
}
},
"additionalProperties": false,
"required": [
"createdAt",
"createdBy"
]
}
},
"additionalProperties": false,
"required": [
"title",
"history"
]
}
},
"validationLevel": "off",
"validationAction": "warn"
});2.1.2.8 Collection notifications
| Property | Value |
| Collection name | notifications |
| Technical name | |
| Activated | true |
| Id | |
| $ref | |
| Description | |
| Database | online_course |
| Capped | |
| Time series | |
| Size | |
| Max | |
| Storage engine | WiredTiger |
| Config String | |
| Validation level | Off |
| Validation action | Warn |
| Encryption metadata | |
| Additional properties | false |
| Comments | |
2.1.2.8.3.1 Field _id
| Property | Value |
| Name | _id |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | false |
| Primary key | true |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.8.3.2 Field sourceId
| Property | Value |
| Name | sourceId |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.8.3.3 Field contextId
| Property | Value |
| Name | contextId |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.8.3.4 Field sourceSlug
| Property | Value |
| Name | sourceSlug |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.8.3.5 Field sourceType
| Property | Value |
| Name | sourceType |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.8.3.6 Field collectionName
| Property | Value |
| Name | collectionName |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.8.3.7 Field receiver
| Property | Value |
| Name | receiver |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to notifications. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.8.3.8 Field content
| Property | Value |
| Name | content |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.8.3.9 Field thumb
| Property | Value |
| Name | thumb |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.8.3.10 Field isRead
| Property | Value |
| Name | isRead |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | boolean |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | false |
| Sample | |
| Comments | |
2.1.2.8.3.11 Field isNew
| Property | Value |
| Name | isNew |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | boolean |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | false |
| Sample | |
| Comments | |
2.1.2.8.3.12 Field createdAt
| Property | Value |
| Name | createdAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
{
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"title": "notifications",
"properties": {
"_id": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"sourceId": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"contextId": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"sourceSlug": {
"type": "string"
},
"sourceType": {
"type": "string"
},
"collectionName": {
"type": "string"
},
"receiver": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"content": {
"type": "string"
},
"thumb": {
"type": "string"
},
"isRead": {
"type": "boolean",
"default": false
},
"isNew": {
"type": "boolean",
"default": false
},
"createdAt": {
"type": "string",
"format": "date-time"
}
},
"additionalProperties": false,
"required": [
"receiver",
"content",
"createdAt"
]
}{
"_id": ObjectId("aedffdbfdf6afd9288720db1"),
"sourceId": ObjectId("ade0029ae7ccd2cd1ffbbe32"),
"contextId": ObjectId("31e4e7ea0b324aedb6efca30"),
"sourceSlug": "Lorem",
"sourceType": "Lorem",
"collectionName": "Lorem",
"receiver": ObjectId("fdffa4a8167d0047b1c55eae"),
"content": "Lorem",
"thumb": "Lorem",
"isRead": false,
"isNew": false,
"createdAt": ISODate("2016-04-08T15:06:21.595Z")
}use online_course;
db.createCollection("notifications", {
"capped": false,
"validator": {
"$jsonSchema": {
"bsonType": "object",
"title": "notifications",
"properties": {
"_id": {
"bsonType": "objectId"
},
"sourceId": {
"bsonType": "objectId"
},
"contextId": {
"bsonType": "objectId"
},
"sourceSlug": {
"bsonType": "string"
},
"sourceType": {
"bsonType": "string"
},
"collectionName": {
"bsonType": "string"
},
"receiver": {
"bsonType": "objectId"
},
"content": {
"bsonType": "string"
},
"thumb": {
"bsonType": "string"
},
"isRead": {
"bsonType": "bool"
},
"isNew": {
"bsonType": "bool"
},
"createdAt": {
"bsonType": "date"
}
},
"additionalProperties": false,
"required": [
"receiver",
"content",
"createdAt"
]
}
},
"validationLevel": "off",
"validationAction": "warn"
});2.1.2.9 Collection orders
| Property | Value |
| Collection name | orders |
| Technical name | |
| Activated | true |
| Id | |
| $ref | |
| Description | |
| Database | online_course |
| Capped | |
| Time series | |
| Size | |
| Max | |
| Storage engine | WiredTiger |
| Config String | |
| Validation level | Off |
| Validation action | Warn |
| Encryption metadata | |
| Additional properties | false |
| Comments | |
2.1.2.9.3.1 Field _id
| Property | Value |
| Name | _id |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | true |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.9.3.2 Field totalPrice
| Property | Value |
| Name | totalPrice |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.9.3.3 Field coursesInOrder
Parent field: orders
Child field(s):
| Property | Value |
| Name | coursesInOrder |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.9.3.4 Field course
| Property | Value |
| Name | course |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | courses |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk courses. to orders. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.9.3.5 Field salePrice
| Property | Value |
| Name | salePrice |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.9.3.6 Field price
| Property | Value |
| Name | price |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.9.3.7 Field moneyConfiguration
Parent field: orders
Child field(s):
| Property | Value |
| Name | moneyConfiguration |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.9.3.8 Field instructorCommission
| Property | Value |
| Name | instructorCommission |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.9.3.9 Field history
Parent field: orders
Child field(s):
| Property | Value |
| Name | history |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.9.3.10 Field createdAt
| Property | Value |
| Name | createdAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.9.3.11 Field createdBy
| Property | Value |
| Name | createdBy |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.9.3.12 Field updatedAt
| Property | Value |
| Name | updatedAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.9.3.13 Field updatedBy
| Property | Value |
| Name | updatedBy |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
{
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"title": "orders",
"properties": {
"_id": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"totalPrice": {
"type": "number"
},
"coursesInOrder": {
"type": "object",
"properties": {
"course": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"salePrice": {
"type": "number"
},
"price": {
"type": "number"
}
},
"additionalProperties": false
},
"moneyConfiguration": {
"type": "object",
"properties": {
"instructorCommission": {
"type": "number"
}
},
"additionalProperties": false
},
"history": {
"type": "object",
"properties": {
"createdAt": {
"type": "string",
"format": "date-time"
},
"createdBy": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"updatedAt": {
"type": "string",
"format": "date-time"
},
"updatedBy": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
}
},
"additionalProperties": false,
"required": [
"createdAt",
"createdBy"
]
}
},
"additionalProperties": false,
"required": [
"history"
]
}{
"_id": ObjectId("db4c6dd7fd0cfcca2cb3aebf"),
"totalPrice": -23,
"coursesInOrder": {
"course": ObjectId("b531ffdf5ee0ea70adc04b30"),
"salePrice": 88,
"price": 1
},
"moneyConfiguration": {
"instructorCommission": 26
},
"history": {
"createdAt": ISODate("2016-04-08T15:06:21.595Z"),
"createdBy": ObjectId("3bbf6c268a721b87ac65b635"),
"updatedAt": ISODate("2016-04-08T15:06:21.595Z"),
"updatedBy": ObjectId("ed84db8f9c4fefa2de26cda2")
}
}use online_course;
db.createCollection("orders", {
"capped": false,
"validator": {
"$jsonSchema": {
"bsonType": "object",
"title": "orders",
"properties": {
"_id": {
"bsonType": "objectId"
},
"totalPrice": {
"bsonType": "number"
},
"coursesInOrder": {
"bsonType": "object",
"properties": {
"course": {
"bsonType": "objectId"
},
"salePrice": {
"bsonType": "number"
},
"price": {
"bsonType": "number"
}
},
"additionalProperties": false
},
"moneyConfiguration": {
"bsonType": "object",
"properties": {
"instructorCommission": {
"bsonType": "number"
}
},
"additionalProperties": false
},
"history": {
"bsonType": "object",
"properties": {
"createdAt": {
"bsonType": "date"
},
"createdBy": {
"bsonType": "objectId"
},
"updatedAt": {
"bsonType": "date"
},
"updatedBy": {
"bsonType": "objectId"
}
},
"additionalProperties": false,
"required": [
"createdAt",
"createdBy"
]
}
},
"additionalProperties": false,
"required": [
"history"
]
}
},
"validationLevel": "off",
"validationAction": "warn"
});2.1.2.10 Collection payments
| Property | Value |
| Collection name | payments |
| Technical name | |
| Activated | true |
| Id | |
| $ref | |
| Description | |
| Database | online_course |
| Capped | |
| Time series | |
| Size | |
| Max | |
| Storage engine | WiredTiger |
| Config String | |
| Validation level | Off |
| Validation action | Warn |
| Encryption metadata | |
| Additional properties | false |
| Comments | |
2.1.2.10.3.1 Field _id
| Property | Value |
| Name | _id |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | true |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.10.3.2 Field status
| Property | Value |
| Name | status |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.10.3.3 Field user
| Property | Value |
| Name | user |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to payments. |
| Cardinality | 1 |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.10.3.4 Field amount
| Property | Value |
| Name | amount |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.10.3.5 Field commissionAmount
| Property | Value |
| Name | commissionAmount |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.10.3.6 Field earnings
| Property | Value |
| Name | earnings |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.10.3.7 Field history
Parent field: payments
Child field(s):
| Property | Value |
| Name | history |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.10.3.8 Field paidAt
| Property | Value |
| Name | paidAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.10.3.9 Field createdAt
| Property | Value |
| Name | createdAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.10.3.10 Field createdBy
| Property | Value |
| Name | createdBy |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.10.3.11 Field updatedAt
| Property | Value |
| Name | updatedAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.10.3.12 Field updatedBy
| Property | Value |
| Name | updatedBy |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
{
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"title": "payments",
"properties": {
"_id": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"status": {
"type": "string"
},
"user": {
"type": "string"
},
"amount": {
"type": "number"
},
"commissionAmount": {
"type": "number"
},
"earnings": {
"type": "number"
},
"history": {
"type": "object",
"properties": {
"paidAt": {
"type": "string",
"format": "date-time"
},
"createdAt": {
"type": "string",
"format": "date-time"
},
"createdBy": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"updatedAt": {
"type": "string",
"format": "date-time"
},
"updatedBy": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
}
},
"additionalProperties": false,
"required": [
"createdAt",
"createdBy"
]
}
},
"additionalProperties": false,
"required": [
"status",
"user",
"history"
]
}{
"_id": ObjectId("f45c4fd65eead6fee4fbf48d"),
"status": "Lorem",
"user": "Lorem",
"amount": -4,
"commissionAmount": 58,
"earnings": -80,
"history": {
"paidAt": ISODate("2016-04-08T15:06:21.595Z"),
"createdAt": ISODate("2016-04-08T15:06:21.595Z"),
"createdBy": ObjectId("01b5f1c8e35ee5c4cafeaeba"),
"updatedAt": ISODate("2016-04-08T15:06:21.595Z"),
"updatedBy": ObjectId("badf7a16c26bebe02dd0bada")
}
}use online_course;
db.createCollection("payments", {
"capped": false,
"validator": {
"$jsonSchema": {
"bsonType": "object",
"title": "payments",
"properties": {
"_id": {
"bsonType": "objectId"
},
"status": {
"bsonType": "string"
},
"user": {
"bsonType": "string"
},
"amount": {
"bsonType": "number"
},
"commissionAmount": {
"bsonType": "number"
},
"earnings": {
"bsonType": "number"
},
"history": {
"bsonType": "object",
"properties": {
"paidAt": {
"bsonType": "date"
},
"createdAt": {
"bsonType": "date"
},
"createdBy": {
"bsonType": "objectId"
},
"updatedAt": {
"bsonType": "date"
},
"updatedBy": {
"bsonType": "objectId"
}
},
"additionalProperties": false,
"required": [
"createdAt",
"createdBy"
]
}
},
"additionalProperties": false,
"required": [
"status",
"user",
"history"
]
}
},
"validationLevel": "off",
"validationAction": "warn"
});2.1.2.11 Collection quizzes
| Property | Value |
| Collection name | quizzes |
| Technical name | |
| Activated | true |
| Id | |
| $ref | |
| Description | |
| Database | online_course |
| Capped | |
| Time series | |
| Size | |
| Max | |
| Storage engine | WiredTiger |
| Config String | |
| Validation level | Off |
| Validation action | Warn |
| Encryption metadata | |
| Additional properties | false |
| Comments | |
2.1.2.11.3.1 Field _id
| Property | Value |
| Name | _id |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | true |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.11.3.2 Field title
| Property | Value |
| Name | title |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.11.3.3 Field description
| Property | Value |
| Name | description |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.11.3.4 Field questions
Parent field: quizzes
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| [0] | document | false | | | |
| Property | Value |
| Name | questions |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | array |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Min items | |
| Max items | |
| Unique items | |
| Additional items | true |
| Comments | |
2.1.2.11.3.5 Field [0]
Parent field: questions
Child field(s):
| Property | Value |
| Display name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.11.3.6 Field questionContent
| Property | Value |
| Name | questionContent |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.11.3.7 Field answerOptions
Parent field: [0]
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| [0] | document | false | | | |
| Property | Value |
| Name | answerOptions |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | array |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Min items | |
| Max items | |
| Unique items | |
| Additional items | true |
| Comments | |
2.1.2.11.3.8 Field [0]
Parent field: answerOptions
Child field(s):
| Property | Value |
| Display name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.11.3.9 Field answerContent
| Property | Value |
| Name | answerContent |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.11.3.10 Field optionNo
| Property | Value |
| Name | optionNo |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.11.3.11 Field description
| Property | Value |
| Name | description |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.11.3.12 Field correctOptionNo
| Property | Value |
| Name | correctOptionNo |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.11.3.13 Field history
Parent field: quizzes
Child field(s):
| Property | Value |
| Name | history |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.11.3.14 Field createdAt
| Property | Value |
| Name | createdAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.11.3.15 Field createdBy
| Property | Value |
| Name | createdBy |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.11.3.16 Field updatedAt
| Property | Value |
| Name | updatedAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.11.3.17 Field updatedBy
| Property | Value |
| Name | updatedBy |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
{
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"title": "quizzes",
"properties": {
"_id": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"title": {
"type": "string"
},
"description": {
"type": "string"
},
"questions": {
"type": "array",
"additionalItems": true,
"items": {
"type": "object",
"properties": {
"questionContent": {
"type": "string"
},
"answerOptions": {
"type": "array",
"additionalItems": true,
"items": {
"type": "object",
"properties": {
"answerContent": {
"type": "string"
},
"optionNo": {
"type": "string"
},
"description": {
"type": "string"
}
},
"additionalProperties": false,
"required": [
"answerContent",
"optionNo"
]
}
},
"correctOptionNo": {
"type": "number"
}
},
"additionalProperties": false,
"required": [
"questionContent",
"correctOptionNo"
]
}
},
"history": {
"type": "object",
"properties": {
"createdAt": {
"type": "string",
"format": "date-time"
},
"createdBy": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"updatedAt": {
"type": "string",
"format": "date-time"
},
"updatedBy": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
}
},
"additionalProperties": false,
"required": [
"createdAt",
"createdBy"
]
}
},
"additionalProperties": false,
"required": [
"title",
"history"
]
}{
"_id": ObjectId("cbdd92d75a0af6479dc4abed"),
"title": "Lorem",
"description": "Lorem",
"questions": [
{
"questionContent": "Lorem",
"answerOptions": [
{
"answerContent": "Lorem",
"optionNo": "Lorem",
"description": "Lorem"
}
],
"correctOptionNo": -57
}
],
"history": {
"createdAt": ISODate("2016-04-08T15:06:21.595Z"),
"createdBy": ObjectId("1fe4b34fdfe25b0b8d8fe739"),
"updatedAt": ISODate("2016-04-08T15:06:21.595Z"),
"updatedBy": ObjectId("5bd19ace5330bebf92f54be3")
}
}use online_course;
db.createCollection("quizzes", {
"capped": false,
"validator": {
"$jsonSchema": {
"bsonType": "object",
"title": "quizzes",
"properties": {
"_id": {
"bsonType": "objectId"
},
"title": {
"bsonType": "string"
},
"description": {
"bsonType": "string"
},
"questions": {
"bsonType": "array",
"additionalItems": true,
"items": {
"bsonType": "object",
"properties": {
"questionContent": {
"bsonType": "string"
},
"answerOptions": {
"bsonType": "array",
"additionalItems": true,
"items": {
"bsonType": "object",
"properties": {
"answerContent": {
"bsonType": "string"
},
"optionNo": {
"bsonType": "string"
},
"description": {
"bsonType": "string"
}
},
"additionalProperties": false,
"required": [
"answerContent",
"optionNo"
]
}
},
"correctOptionNo": {
"bsonType": "number"
}
},
"additionalProperties": false,
"required": [
"questionContent",
"correctOptionNo"
]
}
},
"history": {
"bsonType": "object",
"properties": {
"createdAt": {
"bsonType": "date"
},
"createdBy": {
"bsonType": "objectId"
},
"updatedAt": {
"bsonType": "date"
},
"updatedBy": {
"bsonType": "objectId"
}
},
"additionalProperties": false,
"required": [
"createdAt",
"createdBy"
]
}
},
"additionalProperties": false,
"required": [
"title",
"history"
]
}
},
"validationLevel": "off",
"validationAction": "warn"
});2.1.2.12 Collection reviews
| Property | Value |
| Collection name | reviews |
| Technical name | |
| Activated | true |
| Id | |
| $ref | |
| Description | |
| Database | online_course |
| Capped | |
| Time series | |
| Size | |
| Max | |
| Storage engine | WiredTiger |
| Config String | |
| Validation level | Off |
| Validation action | Warn |
| Encryption metadata | |
| Additional properties | false |
| Comments | |
2.1.2.12.3.1 Field _id
| Property | Value |
| Name | _id |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | false |
| Primary key | true |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.12.3.2 Field rating
| Property | Value |
| Name | rating |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.12.3.3 Field content
| Property | Value |
| Name | content |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.12.3.4 Field user
| Property | Value |
| Name | user |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to comments. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.12.3.5 Field course
| Property | Value |
| Name | course |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | courses |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk courses. to comments. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.12.3.6 Field response
Parent field: reviews
Child field(s):
| Property | Value |
| Name | response |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.12.3.7 Field user
| Property | Value |
| Name | user |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to comments. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.12.3.8 Field content
| Property | Value |
| Name | content |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.12.3.9 Field timestamps
| Property | Value |
| Name | timestamps |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.12.3.10 Field timestamps
Parent field: reviews
Child field(s):
| Property | Value |
| Name | timestamps |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.12.3.11 Field createdAt
| Property | Value |
| Name | createdAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.12.3.12 Field updatedAt
| Property | Value |
| Name | updatedAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
{
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"title": "reviews",
"properties": {
"_id": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"rating": {
"type": "number"
},
"content": {
"type": "string"
},
"user": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"course": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"response": {
"type": "object",
"properties": {
"user": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"content": {
"type": "string"
},
"timestamps": {
"type": "string",
"format": "date-time"
}
},
"additionalProperties": false,
"required": [
"user",
"content",
"timestamps"
]
},
"timestamps": {
"type": "object",
"properties": {
"createdAt": {
"type": "string",
"format": "date-time"
},
"updatedAt": {
"type": "string",
"format": "date-time"
}
},
"additionalProperties": false,
"required": [
"createdAt"
]
}
},
"additionalProperties": false,
"required": [
"rating",
"user",
"course",
"timestamps"
]
}{
"_id": ObjectId("afbae0d2f88b7c8f471aa619"),
"rating": 47,
"content": "Lorem",
"user": ObjectId("111ac4b78265d245dc5c5b2c"),
"course": ObjectId("ce0b5c2c826cebe0bfa34acd"),
"response": {
"user": ObjectId("6cef2755fae8eeebfc8af60c"),
"content": "Lorem",
"timestamps": ISODate("2016-04-08T15:06:21.595Z")
},
"timestamps": {
"createdAt": ISODate("2016-04-08T15:06:21.595Z"),
"updatedAt": ISODate("2016-04-08T15:06:21.595Z")
}
}use online_course;
db.createCollection("reviews", {
"capped": false,
"validator": {
"$jsonSchema": {
"bsonType": "object",
"title": "reviews",
"properties": {
"_id": {
"bsonType": "objectId"
},
"rating": {
"bsonType": "number"
},
"content": {
"bsonType": "string"
},
"user": {
"bsonType": "objectId"
},
"course": {
"bsonType": "objectId"
},
"response": {
"bsonType": "object",
"properties": {
"user": {
"bsonType": "objectId"
},
"content": {
"bsonType": "string"
},
"timestamps": {
"bsonType": "date"
}
},
"additionalProperties": false,
"required": [
"user",
"content",
"timestamps"
]
},
"timestamps": {
"bsonType": "object",
"properties": {
"createdAt": {
"bsonType": "date"
},
"updatedAt": {
"bsonType": "date"
}
},
"additionalProperties": false,
"required": [
"createdAt"
]
}
},
"additionalProperties": false,
"required": [
"rating",
"user",
"course",
"timestamps"
]
}
},
"validationLevel": "off",
"validationAction": "warn"
});2.1.2.13 Collection roles
| Property | Value |
| Collection name | roles |
| Technical name | |
| Activated | true |
| Id | |
| $ref | |
| Description | |
| Database | online_course |
| Capped | |
| Time series | |
| Size | |
| Max | |
| Storage engine | WiredTiger |
| Config String | |
| Validation level | Off |
| Validation action | Warn |
| Encryption metadata | |
| Additional properties | false |
| Comments | |
2.1.2.13.3.1 Field _id
| Property | Value |
| Name | _id |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | false |
| Primary key | true |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.13.3.2 Field name
| Property | Value |
| Name | name |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.13.3.3 Field status
| Property | Value |
| Name | status |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.13.3.4 Field description
| Property | Value |
| Name | description |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.13.3.5 Field ordering
| Property | Value |
| Name | ordering |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.13.3.6 Field permissions
Parent field: roles
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| [0] | document | false | | | |
| Property | Value |
| Name | permissions |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | array |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Min items | |
| Max items | |
| Unique items | |
| Additional items | true |
| Comments | |
2.1.2.13.3.7 Field [0]
Parent field: permissions
Child field(s):
| Property | Value |
| Display name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.13.3.8 Field _id
| Property | Value |
| Name | _id |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.13.3.9 Field documentPermission
| Property | Value |
| Name | documentPermission |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | document_permissions |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk document_permissions. to roles. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.13.3.10 Field enabledPermissions
Parent field: [0]
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| [0] | string | false | | | |
| Property | Value |
| Name | enabledPermissions |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | array |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Min items | |
| Max items | |
| Unique items | |
| Additional items | true |
| Comments | |
2.1.2.13.3.11 Field [0]
| Property | Value |
| Display name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.13.3.12 Field onlyForCreator
| Property | Value |
| Name | onlyForCreator |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | boolean |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | false |
| Sample | |
| Comments | |
2.1.2.13.3.13 Field history
Parent field: roles
Child field(s):
| Property | Value |
| Name | history |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.13.3.14 Field createdAt
| Property | Value |
| Name | createdAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.13.3.15 Field createdBy
| Property | Value |
| Name | createdBy |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.13.3.16 Field updatedAt
| Property | Value |
| Name | updatedAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.13.3.17 Field updatedBy
| Property | Value |
| Name | updatedBy |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
{
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"title": "roles",
"properties": {
"_id": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"name": {
"type": "string"
},
"status": {
"type": "string"
},
"description": {
"type": "string"
},
"ordering": {
"type": "number"
},
"permissions": {
"type": "array",
"additionalItems": true,
"items": {
"type": "object",
"properties": {
"_id": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"documentPermission": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"enabledPermissions": {
"type": "array",
"additionalItems": true,
"items": {
"type": "string"
}
},
"onlyForCreator": {
"type": "boolean",
"default": false
}
},
"additionalProperties": false
}
},
"history": {
"type": "object",
"properties": {
"createdAt": {
"type": "string",
"format": "date-time"
},
"createdBy": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"updatedAt": {
"type": "string",
"format": "date-time"
},
"updatedBy": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
}
},
"additionalProperties": false,
"required": [
"createdAt",
"createdBy"
]
}
},
"additionalProperties": false,
"required": [
"name",
"status",
"ordering",
"history"
]
}{
"_id": ObjectId("3a1a415ef02eacee1fbc3966"),
"name": "Lorem",
"status": "Lorem",
"description": "Lorem",
"ordering": -43,
"permissions": [
{
"_id": ObjectId("52bfd50c0a2fe131f99bafe5"),
"documentPermission": ObjectId("6b36dc39fe656cc7d9ce3afc"),
"enabledPermissions": [
"Lorem"
],
"onlyForCreator": false
}
],
"history": {
"createdAt": ISODate("2016-04-08T15:06:21.595Z"),
"createdBy": ObjectId("fedea57a8815fd2cf13e7bcf"),
"updatedAt": ISODate("2016-04-08T15:06:21.595Z"),
"updatedBy": ObjectId("79d193d2e07ebbac3ea3cef0")
}
}use online_course;
db.createCollection("roles", {
"capped": false,
"validator": {
"$jsonSchema": {
"bsonType": "object",
"title": "roles",
"properties": {
"_id": {
"bsonType": "objectId"
},
"name": {
"bsonType": "string"
},
"status": {
"bsonType": "string"
},
"description": {
"bsonType": "string"
},
"ordering": {
"bsonType": "number"
},
"permissions": {
"bsonType": "array",
"additionalItems": true,
"items": {
"bsonType": "object",
"properties": {
"_id": {
"bsonType": "objectId"
},
"documentPermission": {
"bsonType": "objectId"
},
"enabledPermissions": {
"bsonType": "array",
"additionalItems": true,
"items": {
"bsonType": "string"
}
},
"onlyForCreator": {
"bsonType": "bool"
}
},
"additionalProperties": false
}
},
"history": {
"bsonType": "object",
"properties": {
"createdAt": {
"bsonType": "date"
},
"createdBy": {
"bsonType": "objectId"
},
"updatedAt": {
"bsonType": "date"
},
"updatedBy": {
"bsonType": "objectId"
}
},
"additionalProperties": false,
"required": [
"createdAt",
"createdBy"
]
}
},
"additionalProperties": false,
"required": [
"name",
"status",
"ordering",
"history"
]
}
},
"validationLevel": "off",
"validationAction": "warn"
});2.1.2.14 Collection sliders
| Property | Value |
| Collection name | sliders |
| Technical name | |
| Activated | true |
| Id | |
| $ref | |
| Description | |
| Database | online_course |
| Capped | |
| Time series | |
| Size | |
| Max | |
| Storage engine | WiredTiger |
| Config String | |
| Validation level | Off |
| Validation action | Warn |
| Encryption metadata | |
| Additional properties | false |
| Comments | |
2.1.2.14.3.1 Field _id
| Property | Value |
| Name | _id |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | true |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.14.3.2 Field name
| Property | Value |
| Name | name |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.14.3.3 Field status
| Property | Value |
| Name | status |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.14.3.4 Field description
| Property | Value |
| Name | description |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.14.3.5 Field avatar
| Property | Value |
| Name | avatar |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | sliders |
| Foreign field | name |
| Relationship type | Foreign Key |
| Relationship name | fk sliders.name to sliders.avatar |
| Cardinality | 1 |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.14.3.6 Field history
Parent field: sliders
Child field(s):
| Property | Value |
| Name | history |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.14.3.7 Field createdAt
| Property | Value |
| Name | createdAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.14.3.8 Field createdBy
| Property | Value |
| Name | createdBy |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.14.3.9 Field updatedAt
| Property | Value |
| Name | updatedAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.14.3.10 Field updatedBy
| Property | Value |
| Name | updatedBy |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to courses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
{
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"title": "sliders",
"properties": {
"_id": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"name": {
"type": "string"
},
"status": {
"type": "string"
},
"description": {
"type": "string"
},
"avatar": {
"type": "string"
},
"history": {
"type": "object",
"properties": {
"createdAt": {
"type": "string",
"format": "date-time"
},
"createdBy": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"updatedAt": {
"type": "string",
"format": "date-time"
},
"updatedBy": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
}
},
"additionalProperties": false,
"required": [
"createdAt",
"createdBy"
]
}
},
"additionalProperties": false,
"required": [
"name",
"status",
"history"
]
}{
"_id": ObjectId("2a8717f6b5abcfbae3e1a5ca"),
"name": "Lorem",
"status": "Lorem",
"description": "Lorem",
"avatar": "Lorem",
"history": {
"createdAt": ISODate("2016-04-08T15:06:21.595Z"),
"createdBy": ObjectId("da57bff14c86050b9aadba79"),
"updatedAt": ISODate("2016-04-08T15:06:21.595Z"),
"updatedBy": ObjectId("b1fac9a9aef86bb1a1c0098f")
}
}use online_course;
db.createCollection("sliders", {
"capped": false,
"validator": {
"$jsonSchema": {
"bsonType": "object",
"title": "sliders",
"properties": {
"_id": {
"bsonType": "objectId"
},
"name": {
"bsonType": "string"
},
"status": {
"bsonType": "string"
},
"description": {
"bsonType": "string"
},
"avatar": {
"bsonType": "string"
},
"history": {
"bsonType": "object",
"properties": {
"createdAt": {
"bsonType": "date"
},
"createdBy": {
"bsonType": "objectId"
},
"updatedAt": {
"bsonType": "date"
},
"updatedBy": {
"bsonType": "objectId"
}
},
"additionalProperties": false,
"required": [
"createdAt",
"createdBy"
]
}
},
"additionalProperties": false,
"required": [
"name",
"status",
"history"
]
}
},
"validationLevel": "off",
"validationAction": "warn"
});2.1.2.15 Collection transactions
| Property | Value |
| Collection name | transactions |
| Technical name | |
| Activated | true |
| Id | |
| $ref | |
| Description | |
| Database | online_course |
| Capped | |
| Time series | |
| Size | |
| Max | |
| Storage engine | WiredTiger |
| Config String | |
| Validation level | Off |
| Validation action | Warn |
| Encryption metadata | |
| Additional properties | false |
| Comments | |
2.1.2.15.3.1 Field _id
| Property | Value |
| Name | _id |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | false |
| Primary key | true |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.15.3.2 Field payment
| Property | Value |
| Name | payment |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | payments |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk payments. to transactions. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.15.3.3 Field customer
| Property | Value |
| Name | customer |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to transactions. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.15.3.4 Field instructor
| Property | Value |
| Name | instructor |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to transactions. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.15.3.5 Field course
| Property | Value |
| Name | course |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | courses |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk courses. to transactions. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.15.3.6 Field salePrice
| Property | Value |
| Name | salePrice |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.15.3.7 Field moneyConfiguration
Parent field: transactions
Child field(s):
| Property | Value |
| Name | moneyConfiguration |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.15.3.8 Field instructorCommission
| Property | Value |
| Name | instructorCommission |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.15.3.9 Field timestamps
Parent field: transactions
Child field(s):
| Property | Value |
| Name | timestamps |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.15.3.10 Field createdAt
| Property | Value |
| Name | createdAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.15.3.11 Field updatedAt
| Property | Value |
| Name | updatedAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
{
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"title": "transactions",
"properties": {
"_id": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"payment": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"customer": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"instructor": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"course": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"salePrice": {
"type": "number"
},
"moneyConfiguration": {
"type": "object",
"properties": {
"instructorCommission": {
"type": "number"
}
},
"additionalProperties": false
},
"timestamps": {
"type": "object",
"properties": {
"createdAt": {
"type": "string",
"format": "date-time"
},
"updatedAt": {
"type": "string",
"format": "date-time"
}
},
"additionalProperties": false,
"required": [
"createdAt"
]
}
},
"additionalProperties": false,
"required": [
"payment",
"customer",
"instructor",
"course",
"salePrice",
"moneyConfiguration",
"timestamps"
]
}{
"_id": ObjectId("ead810fa79e23d94c8cd60e3"),
"payment": ObjectId("1085f5438aba11f7b9deff74"),
"customer": ObjectId("977cb614912be9387c6e737d"),
"instructor": ObjectId("3410abffeb924bd02f33ef9e"),
"course": ObjectId("caa0bd3f7a8cec6eb912edac"),
"salePrice": -74,
"moneyConfiguration": {
"instructorCommission": 14
},
"timestamps": {
"createdAt": ISODate("2016-04-08T15:06:21.595Z"),
"updatedAt": ISODate("2016-04-08T15:06:21.595Z")
}
}use online_course;
db.createCollection("transactions", {
"capped": false,
"validator": {
"$jsonSchema": {
"bsonType": "object",
"title": "transactions",
"properties": {
"_id": {
"bsonType": "objectId"
},
"payment": {
"bsonType": "objectId"
},
"customer": {
"bsonType": "objectId"
},
"instructor": {
"bsonType": "objectId"
},
"course": {
"bsonType": "objectId"
},
"salePrice": {
"bsonType": "number"
},
"moneyConfiguration": {
"bsonType": "object",
"properties": {
"instructorCommission": {
"bsonType": "number"
}
},
"additionalProperties": false
},
"timestamps": {
"bsonType": "object",
"properties": {
"createdAt": {
"bsonType": "date"
},
"updatedAt": {
"bsonType": "date"
}
},
"additionalProperties": false,
"required": [
"createdAt"
]
}
},
"additionalProperties": false,
"required": [
"payment",
"customer",
"instructor",
"course",
"salePrice",
"moneyConfiguration",
"timestamps"
]
}
},
"validationLevel": "off",
"validationAction": "warn"
});2.1.2.16 Collection usercourses
| Property | Value |
| Collection name | usercourses |
| Technical name | |
| Activated | true |
| Id | |
| $ref | |
| Description | |
| Database | online_course |
| Capped | |
| Time series | |
| Size | |
| Max | |
| Storage engine | WiredTiger |
| Config String | |
| Validation level | Off |
| Validation action | Warn |
| Encryption metadata | |
| Additional properties | false |
| Comments | |
2.1.2.16.3.1 Field _id
| Property | Value |
| Name | _id |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | false |
| Primary key | true |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.16.3.2 Field course
| Property | Value |
| Name | course |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | courses |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk courses. to usercourses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.16.3.3 Field user
| Property | Value |
| Name | user |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | users |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk users. to comments. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.16.3.4 Field learnDetail
Parent field: usercourses
Child field(s):
| Property | Value |
| Name | learnDetail |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.16.3.5 Field learnUnits
Parent field: learnDetail
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| [0] | document | false | | | |
| Property | Value |
| Name | learnUnits |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | array |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Min items | |
| Max items | |
| Unique items | |
| Additional items | true |
| Comments | |
2.1.2.16.3.6 Field [0]
Parent field: learnUnits
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| unitId | objectId | false | | | |
| learnQuiz | document | false | | | |
| Property | Value |
| Display name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.16.3.7 Field unitId
| Property | Value |
| Name | unitId |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.16.3.8 Field learnQuiz
Parent field: [0]
Child field(s):
| Property | Value |
| Name | learnQuiz |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.16.3.9 Field quiz
| Property | Value |
| Name | quiz |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | quizzes |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk quizzes. to usercourses. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.16.3.10 Field questionAnswers
Parent field: learnQuiz
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| [0] | document | false | | | |
| Property | Value |
| Name | questionAnswers |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | array |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Min items | |
| Max items | |
| Unique items | |
| Additional items | true |
| Comments | |
2.1.2.16.3.11 Field [0]
Parent field: questionAnswers
Child field(s):
| Property | Value |
| Display name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.16.3.12 Field question
| Property | Value |
| Name | question |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.16.3.13 Field answerNo
| Property | Value |
| Name | answerNo |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.16.3.14 Field skipQuestions
Parent field: learnQuiz
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| [0] | objectId | false | | | |
| Property | Value |
| Name | skipQuestions |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | array |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Min items | |
| Max items | |
| Unique items | |
| Additional items | true |
| Comments | |
2.1.2.16.3.15 Field [0]
| Property | Value |
| Display name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.16.3.16 Field currentQuestionIdx
| Property | Value |
| Name | currentQuestionIdx |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.16.3.17 Field status
| Property | Value |
| Name | status |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.16.3.18 Field activeContentIds
Parent field: learnDetail
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| [0] | string | false | | | |
| [1] | string | false | | | |
| Property | Value |
| Name | activeContentIds |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | array |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Min items | |
| Max items | |
| Unique items | |
| Additional items | true |
| Comments | |
2.1.2.16.3.19 Field [0]
| Property | Value |
| Display name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.16.3.20 Field [1]
| Property | Value |
| Display name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.16.3.21 Field progress
| Property | Value |
| Name | progress |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | numeric |
| Subtype | |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Unit | |
| Min value | |
| Excl min | |
| Max value | |
| Excl max | |
| Multiple of | |
| Divisible by | |
| Enum | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.16.3.22 Field archived
Parent field: usercourses
Child field(s):
| Property | Value |
| Name | archived |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.16.3.23 Field isArchived
| Property | Value |
| Name | isArchived |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | boolean |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | false |
| Sample | |
| Comments | |
2.1.2.16.3.24 Field timestamp
| Property | Value |
| Name | timestamp |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.16.3.25 Field timestamps
Parent field: usercourses
Child field(s):
| Property | Value |
| Name | timestamps |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.16.3.26 Field createdAt
| Property | Value |
| Name | createdAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.16.3.27 Field updatedAt
| Property | Value |
| Name | updatedAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
{
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"title": "usercourses",
"properties": {
"_id": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"course": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"user": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"learnDetail": {
"type": "object",
"properties": {
"learnUnits": {
"type": "array",
"additionalItems": true,
"items": {
"type": "object",
"properties": {
"unitId": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"learnQuiz": {
"type": "object",
"properties": {
"quiz": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"questionAnswers": {
"type": "array",
"additionalItems": true,
"items": {
"type": "object",
"properties": {
"question": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"answerNo": {
"type": "number"
}
},
"additionalProperties": false,
"required": [
"question",
"answerNo"
]
}
},
"skipQuestions": {
"type": "array",
"additionalItems": true,
"items": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
}
},
"currentQuestionIdx": {
"type": "number"
},
"status": {
"type": "string"
}
},
"additionalProperties": false,
"required": [
"status"
]
}
},
"additionalProperties": false
}
},
"activeContentIds": {
"type": "array",
"additionalItems": true,
"items": [
{
"type": "string"
},
{
"type": "string"
}
]
},
"progress": {
"type": "number"
}
},
"additionalProperties": false
},
"archived": {
"type": "object",
"properties": {
"isArchived": {
"type": "boolean",
"default": false
},
"timestamp": {
"type": "string",
"format": "date-time"
}
},
"additionalProperties": false
},
"timestamps": {
"type": "object",
"properties": {
"createdAt": {
"type": "string",
"format": "date-time"
},
"updatedAt": {
"type": "string",
"format": "date-time"
}
},
"additionalProperties": false,
"required": [
"createdAt"
]
}
},
"additionalProperties": false,
"required": [
"course",
"user",
"timestamps"
]
}{
"_id": ObjectId("6259accec931b0e4e6a8a0ec"),
"course": ObjectId("0dc8a397d913ac8babeeeefc"),
"user": ObjectId("d41dd2dcc026ab1136cce1ee"),
"learnDetail": {
"learnUnits": [
{
"unitId": ObjectId("2e4e16e131343f728b0362e5"),
"learnQuiz": {
"quiz": ObjectId("be8fe3ccda6d3b7f171f9dbc"),
"questionAnswers": [
{
"question": ObjectId("a97dcce44f11885b13caaf51"),
"answerNo": -9
}
],
"skipQuestions": [
ObjectId("bab8babacc1aaeacbaff5d9a")
],
"currentQuestionIdx": -96,
"status": "Lorem"
}
}
],
"activeContentIds": [
"Lorem",
"Lorem"
],
"progress": 82
},
"archived": {
"isArchived": false,
"timestamp": ISODate("2016-04-08T15:06:21.595Z")
},
"timestamps": {
"createdAt": ISODate("2016-04-08T15:06:21.595Z"),
"updatedAt": ISODate("2016-04-08T15:06:21.595Z")
}
}use online_course;
db.createCollection("usercourses", {
"capped": false,
"validator": {
"$jsonSchema": {
"bsonType": "object",
"title": "usercourses",
"properties": {
"_id": {
"bsonType": "objectId"
},
"course": {
"bsonType": "objectId"
},
"user": {
"bsonType": "objectId"
},
"learnDetail": {
"bsonType": "object",
"properties": {
"learnUnits": {
"bsonType": "array",
"additionalItems": true,
"items": {
"bsonType": "object",
"properties": {
"unitId": {
"bsonType": "objectId"
},
"learnQuiz": {
"bsonType": "object",
"properties": {
"quiz": {
"bsonType": "objectId"
},
"questionAnswers": {
"bsonType": "array",
"additionalItems": true,
"items": {
"bsonType": "object",
"properties": {
"question": {
"bsonType": "objectId"
},
"answerNo": {
"bsonType": "number"
}
},
"additionalProperties": false,
"required": [
"question",
"answerNo"
]
}
},
"skipQuestions": {
"bsonType": "array",
"additionalItems": true,
"items": {
"bsonType": "objectId"
}
},
"currentQuestionIdx": {
"bsonType": "number"
},
"status": {
"bsonType": "string"
}
},
"additionalProperties": false,
"required": [
"status"
]
}
},
"additionalProperties": false
}
},
"activeContentIds": {
"bsonType": "array",
"additionalItems": true,
"items": [
{
"bsonType": "string"
},
{
"bsonType": "string"
}
]
},
"progress": {
"bsonType": "number"
}
},
"additionalProperties": false
},
"archived": {
"bsonType": "object",
"properties": {
"isArchived": {
"bsonType": "bool"
},
"timestamp": {
"bsonType": "date"
}
},
"additionalProperties": false
},
"timestamps": {
"bsonType": "object",
"properties": {
"createdAt": {
"bsonType": "date"
},
"updatedAt": {
"bsonType": "date"
}
},
"additionalProperties": false,
"required": [
"createdAt"
]
}
},
"additionalProperties": false,
"required": [
"course",
"user",
"timestamps"
]
}
},
"validationLevel": "off",
"validationAction": "warn"
});2.1.2.17 Collection users
| Property | Value |
| Collection name | users |
| Technical name | |
| Activated | true |
| Id | |
| $ref | |
| Description | |
| Database | online_course |
| Capped | |
| Time series | |
| Size | |
| Max | |
| Storage engine | WiredTiger |
| Config String | |
| Validation level | Off |
| Validation action | Warn |
| Encryption metadata | |
| Additional properties | false |
| Comments | |
2.1.2.17.3.1 Field _id
| Property | Value |
| Name | _id |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | true |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Sample | |
| Comments | |
2.1.2.17.3.2 Field email
| Property | Value |
| Name | email |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.17.3.3 Field password
| Property | Value |
| Name | password |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.17.3.4 Field status
| Property | Value |
| Name | status |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.17.3.5 Field role
| Property | Value |
| Name | role |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.17.3.6 Field profile
Parent field: users
Child field(s):
| Property | Value |
| Name | profile |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.17.3.7 Field avatar
| Property | Value |
| Name | avatar |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.17.3.8 Field firstName
| Property | Value |
| Name | firstName |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.17.3.9 Field lastName
| Property | Value |
| Name | lastName |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | true |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.17.3.10 Field fullName
| Property | Value |
| Name | fullName |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.17.3.11 Field phone
| Property | Value |
| Name | phone |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.17.3.12 Field address
| Property | Value |
| Name | address |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.17.3.13 Field providers
Parent field: users
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| [0] | string | false | | | |
| Property | Value |
| Name | providers |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | array |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Min items | |
| Max items | |
| Unique items | |
| Additional items | true |
| Comments | |
2.1.2.17.3.14 Field [0]
| Property | Value |
| Display name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.17.3.15 Field refreshToken
| Property | Value |
| Name | refreshToken |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.17.3.16 Field myCourses
Parent field: users
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| wishlist | array | false | | | |
| Property | Value |
| Name | myCourses |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.17.3.17 Field wishlist
Parent field: myCourses
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| [0] | objectId | false | | | |
| Property | Value |
| Name | wishlist |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | array |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Min items | |
| Max items | |
| Unique items | |
| Additional items | true |
| Comments | |
2.1.2.17.3.18 Field [0]
| Property | Value |
| Display name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Primary key | |
| Foreign collection | courses |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk courses. to users. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.17.3.19 Field cart
Parent field: users
Child field(s):
| Field | Type | Req | Key | Description | Comments |
| courses | objectId | false | | | |
| Property | Value |
| Name | cart |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | document |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| DBRef | |
| Min Properties | |
| Max Properties | |
| Additional properties | false |
| Comments | |
2.1.2.17.3.20 Field courses
| Property | Value |
| Name | courses |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | objectId |
| Description | |
| Dependencies | |
| Required | |
| Primary key | |
| Foreign collection | courses |
| Foreign field | _id |
| Relationship type | Foreign Key |
| Relationship name | fk courses. to users. |
| Cardinality | 1 |
| Default | |
| Sample | |
| Comments | |
2.1.2.17.3.21 Field createdAt
| Property | Value |
| Name | createdAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | true |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.17.3.22 Field updatedAt
| Property | Value |
| Name | updatedAt |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | date |
| Description | |
| Dependencies | |
| Required | |
| Primary key | false |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Default | |
| Now | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.17.3.23 Field permissionToken
| Property | Value |
| Name | permissionToken |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
2.1.2.17.3.24 Field permissionTokenTimestamp
| Property | Value |
| Name | permissionTokenTimestamp |
| Technical name | |
| Activated | true |
| Id | |
| Field-level encryption | |
| Type | string |
| Description | |
| Format | |
| Pattern | |
| Min length | |
| Max length | |
| Default | |
| Enum | |
| Required | |
| Primary key | |
| Dependencies | |
| Foreign collection | |
| Foreign field | |
| Relationship type | |
| Relationship name | |
| Cardinality | |
| Faker function | |
| Sample | |
| Comments | |
{
"$schema": "http://json-schema.org/draft-04/schema#",
"type": "object",
"title": "users",
"properties": {
"_id": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
},
"email": {
"type": "string"
},
"password": {
"type": "string"
},
"status": {
"type": "string"
},
"role": {
"type": "string"
},
"profile": {
"type": "object",
"properties": {
"avatar": {
"type": "string"
},
"firstName": {
"type": "string"
},
"lastName": {
"type": "string"
},
"fullName": {
"type": "string"
},
"phone": {
"type": "string"
},
"address": {
"type": "string"
}
},
"additionalProperties": false,
"required": [
"firstName",
"lastName"
]
},
"providers": {
"type": "array",
"additionalItems": true,
"items": {
"type": "string"
}
},
"refreshToken": {
"type": "string"
},
"myCourses": {
"type": "object",
"properties": {
"wishlist": {
"type": "array",
"additionalItems": true,
"items": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
}
}
},
"additionalProperties": false
},
"cart": {
"type": "object",
"properties": {
"courses": {
"type": "string",
"pattern": "^[a-fA-F0-9]{24}$"
}
},
"additionalProperties": false
},
"createdAt": {
"type": "string",
"format": "date-time"
},
"updatedAt": {
"type": "string",
"format": "date-time"
},
"permissionToken": {
"type": "string"
},
"permissionTokenTimestamp": {
"type": "string"
}
},
"additionalProperties": false,
"required": [
"email",
"password",
"status",
"role",
"createdAt"
]
}{
"_id": ObjectId("c3d3b1be5407edba1000afe7"),
"email": "Lorem",
"password": "Lorem",
"status": "Lorem",
"role": "Lorem",
"profile": {
"avatar": "Lorem",
"firstName": "Lorem",
"lastName": "Lorem",
"fullName": "Lorem",
"phone": "Lorem",
"address": "Lorem"
},
"providers": [
"Lorem"
],
"refreshToken": "Lorem",
"myCourses": {
"wishlist": [
ObjectId("2ae57cc11ca12281dd39c6ea")
]
},
"cart": {
"courses": ObjectId("c9ae9b8cda7fc58c36ae9a5b")
},
"createdAt": ISODate("2016-04-08T15:06:21.595Z"),
"updatedAt": ISODate("2016-04-08T15:06:21.595Z"),
"permissionToken": "Lorem",
"permissionTokenTimestamp": "Lorem"
}use online_course;
db.createCollection("users", {
"capped": false,
"validator": {
"$jsonSchema": {
"bsonType": "object",
"title": "users",
"properties": {
"_id": {
"bsonType": "objectId"
},
"email": {
"bsonType": "string"
},
"password": {
"bsonType": "string"
},
"status": {
"bsonType": "string"
},
"role": {
"bsonType": "string"
},
"profile": {
"bsonType": "object",
"properties": {
"avatar": {
"bsonType": "string"
},
"firstName": {
"bsonType": "string"
},
"lastName": {
"bsonType": "string"
},
"fullName": {
"bsonType": "string"
},
"phone": {
"bsonType": "string"
},
"address": {
"bsonType": "string"
}
},
"additionalProperties": false,
"required": [
"firstName",
"lastName"
]
},
"providers": {
"bsonType": "array",
"additionalItems": true,
"items": {
"bsonType": "string"
}
},
"refreshToken": {
"bsonType": "string"
},
"myCourses": {
"bsonType": "object",
"properties": {
"wishlist": {
"bsonType": "array",
"additionalItems": true,
"items": {
"bsonType": "objectId"
}
}
},
"additionalProperties": false
},
"cart": {
"bsonType": "object",
"properties": {
"courses": {
"bsonType": "objectId"
}
},
"additionalProperties": false
},
"createdAt": {
"bsonType": "date"
},
"updatedAt": {
"bsonType": "date"
},
"permissionToken": {
"bsonType": "string"
},
"permissionTokenTimestamp": {
"bsonType": "string"
}
},
"additionalProperties": false,
"required": [
"email",
"password",
"status",
"role",
"createdAt"
]
}
},
"validationLevel": "off",
"validationAction": "warn"
});